package com.kunya.cms.config;

import com.mchange.v2.c3p0.ComboPooledDataSource;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

import java.beans.PropertyVetoException;

/**
 * @author zp
 * @Description:
 * @date 2018/5/6 23:21
 */

@Configuration
@MapperScan("com.kunya.cms.dao")
public class DataSourceConfiguration {
    @Value("${jdbc.driver}")
    private String jdbcDriver;
    @Value("${jdbc.url}")
    private  String jdbcUrl;
    @Value("${jdbc.username}")
    private  String jdbcUsername;
    @Value("${jdbc.password}")
    private String jdbcPassword;

    @Bean(name= "dataSource")
    public ComboPooledDataSource CreateDataSource() throws PropertyVetoException{

        ComboPooledDataSource dataSource=new ComboPooledDataSource();
        dataSource.setDriverClass(jdbcDriver);
        dataSource.setJdbcUrl(jdbcUrl);
        dataSource.setUser(jdbcUsername);
        dataSource.setPassword(jdbcPassword);

        //关闭连接后不自动commit
        dataSource.setAutoCommitOnClose(false);

        return  dataSource;

    }
}
